package pro.spring.inter;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import pro.spring.model.Users;

public interface UsersMapper {
    int deleteByPrimaryKey(Integer uId);

    int insert(Users record);

    int insertSelective(Users record);

    Users selectByPrimaryKey(Integer uId);

    int updateByPrimaryKeySelective(Users record);

    int updateByPrimaryKey(Users record);
    
    int selectName(@Param("name")String name);
    
    //得到总条数
    Integer selectCount();
    
    //email 验证
    Users selectByEmail(@Param("email")String email);
    
    //account 验证
    Integer selectByAccount(@Param("account")String account);
    
    //select by theme_id
    Users selectByThemeId(@Param("themid")Integer id);
    
    //得到总条数
    Users selectLogin(@Param("name")String name,@Param("pass")String password);
    
    //分页查询
    List<Users> selectListPage(@Param("offset")Integer offset,@Param("pagesize")Integer pagesize);
}